UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NAsbCqE+fd1irai/vRpXoCQgO0rPzTZZirX9jI7y1x8='
WHERE
key_id = '3e072c533e83ec58989d30a6f3b6cca9e9856776dad4195883a203e15568f33d'
AND (
token = 'NAsbCqE+fd1irai/vRpXoCQgO0rPzTZZirX9jI7y1x8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)