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