UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c0xJmLpAJZNcXIbiWtusFyeY3b/VKoKLolpylq9dZv4='
WHERE
key_id = 'f9b35b63817d31985dd2ef224b83095bd625305c079bb8cf07f9117f59ab9438'
AND (
token = 'c0xJmLpAJZNcXIbiWtusFyeY3b/VKoKLolpylq9dZv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)