UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zoUP99z35Os+qrA2s71E583jBrHkAV8AjhOxfDOnUMg='
WHERE
key_id = '9b5ed606cbadbd2ba6535ebcf7235f79c9c1159be8396cc4005f30512529d8a0'
AND (
token = 'zoUP99z35Os+qrA2s71E583jBrHkAV8AjhOxfDOnUMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)