UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pk7nEwuhGmR97LPG9L9yGMi0giM+gl9xNq7wf4I9SMw='
WHERE
key_id = 'd0a838864898eaab42a5f075b0f08f1b4b08cbca9391eb54f8b64c4382159165'
AND (
token = 'Pk7nEwuhGmR97LPG9L9yGMi0giM+gl9xNq7wf4I9SMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)