UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TR+h5cJvHl2TRMEFah0bPYIZ6Pbjy0kfBFwnAr6lzUE='
WHERE
key_id = '7b34120eb7337eac4b615b1cb3a10335d4325511087cd78470a6ff3134115bdf'
AND (
token = 'TR+h5cJvHl2TRMEFah0bPYIZ6Pbjy0kfBFwnAr6lzUE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)