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