UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Y0D4ITZIYChy3NrR2PrpCUebsUdF0Tel3a0rrzvYKw='
WHERE
key_id = '34c02a24c02cb23970f07017a88e334cd8b2c541361315c5b6f2358894503398'
AND (
token = '9Y0D4ITZIYChy3NrR2PrpCUebsUdF0Tel3a0rrzvYKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)