UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NJ59LFi/B3ipdalX5xE8+RDDopb+3bdmcrrhk+/b7D4='
WHERE
key_id = 'cb1cf415ec0cd51551def116c386a9a336513e5ddbc325eb827af19a35db0969'
AND (
token = 'NJ59LFi/B3ipdalX5xE8+RDDopb+3bdmcrrhk+/b7D4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)