UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ifHsHtzOAE6TXW+5Y7YcD62dA3tBaKZrTNvG3Qm8COQ='
WHERE
key_id = 'b1f5950c8b8eb093d8a599ba522e7bd3dd8da642cf73ab1c8cf060dd0d483443'
AND (
token = 'ifHsHtzOAE6TXW+5Y7YcD62dA3tBaKZrTNvG3Qm8COQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)