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