UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O6TctjFK8KYY2i9/krnzAPuFkd40mhHGidFKBOyuN4Y='
WHERE
key_id = 'ff9b0aa98092617f3b81353ecf6eaa8bcf3808ca15a5a9de599413d895aba60c'
AND (
token = 'O6TctjFK8KYY2i9/krnzAPuFkd40mhHGidFKBOyuN4Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)