UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zXQ64UmgrnKfK8dA+Aa86LRnE8reB//rXhLPHz+rRD4='
WHERE
key_id = 'a1f46834f4a5637e7638d7b717cb289afc1c439145eeb7076662e94315b73b87'
AND (
token = 'zXQ64UmgrnKfK8dA+Aa86LRnE8reB//rXhLPHz+rRD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)