UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8dK6b3QT0MxIJBP3iGHqyFg45IG7n6hODA/FmkaYJQw='
WHERE
key_id = '78bcca06274d76e8f16aa05b052d34a16ec0a8b0090421b5501497fcf35f1890'
AND (
token = '8dK6b3QT0MxIJBP3iGHqyFg45IG7n6hODA/FmkaYJQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)