UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xs5LnOog0PZPWWMBpa338kMOZ5rCp9gxrO+2iN1+5lI='
WHERE
key_id = 'b81259e06899dc24f92e759b242a140c537a26283f321b1b887be5e5207d289b'
AND (
token = 'xs5LnOog0PZPWWMBpa338kMOZ5rCp9gxrO+2iN1+5lI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)