UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6lFZG4E0YCU4ObqpwaAm/BxIfRFBJomYPed8o6S5ScE='
WHERE
key_id = 'e589c4ff29dcd3a8d5215f5a860aaf6bacd6dba4010199975921c76a13374b0d'
AND (
token = '6lFZG4E0YCU4ObqpwaAm/BxIfRFBJomYPed8o6S5ScE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)