UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0fhen8+VEHuIq97lZe/DdhbTUXAdGr4XPYzUUv2NgOs='
WHERE
key_id = '2a78e1a0785ae61f49e9adc134a6513bf4927a4457964bb46b2c96fb46e93665'
AND (
token = '0fhen8+VEHuIq97lZe/DdhbTUXAdGr4XPYzUUv2NgOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)