UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '77QFKtxXLS18fwKSeLUhb0EhjMlxvxnI9gG5jr7dS6k='
WHERE
key_id = '2e91e5d3fc7987749c8fc157724bbf76e3e9499455f3ff700622dc713fb9f355'
AND (
token = '77QFKtxXLS18fwKSeLUhb0EhjMlxvxnI9gG5jr7dS6k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)