UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'We6YSlSD/DQ//mbvOfaCJRvQfd12yNUEbAivdO4wnnU='
WHERE
key_id = '85c37d9e1620a5e167f820c893f74700ef893781adb0bec9fe8ebbfb50b8c915'
AND (
token = 'We6YSlSD/DQ//mbvOfaCJRvQfd12yNUEbAivdO4wnnU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)