UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lq9nHKnLebnlN8QXIqiH7h5Uyyw9YEKAEyKdUDkQpEw='
WHERE
key_id = '123ae4915c74fbe7f063b06c0f3b7fefd5b003de768672486efc2f17ceae621c'
AND (
token = 'lq9nHKnLebnlN8QXIqiH7h5Uyyw9YEKAEyKdUDkQpEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)