UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iOk4zdMgTtq1BaQOTJIc8IgSjLsaeG6Us1aO5AcDcyE='
WHERE
key_id = 'ec5c4a783ed1b63167cf3ffc31aae5b88d3bcf2f2a7a93dc5215340591838be2'
AND (
token = 'iOk4zdMgTtq1BaQOTJIc8IgSjLsaeG6Us1aO5AcDcyE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)