UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o9iQ3QyfFmydkjZc/rP80laTwClXIrroy+qSudL+CGY='
WHERE
key_id = '3de7fd4dd9c0813cc60a8a246cdb5bcca063082d8c8d07dc1cabf1f266b6b585'
AND (
token = 'o9iQ3QyfFmydkjZc/rP80laTwClXIrroy+qSudL+CGY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)