UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eNVT2rk1KvAD0iHM8ImeqQYOkW6gzdqrRqCMHJosxHw='
WHERE
key_id = 'b624b8be10c1c210babd476446a56cf9b3077f19c272f08402ddce5f77873a83'
AND (
token = 'eNVT2rk1KvAD0iHM8ImeqQYOkW6gzdqrRqCMHJosxHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)