UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pCFrqA85X+sPCOpp3cAiN4ixCdNHoETZN7yL147+smg='
WHERE
key_id = '34d0933d0521c4b5aa1a0e18ea2e17f61d0e55e0765894c45c929c7548af4ffb'
AND (
token = 'pCFrqA85X+sPCOpp3cAiN4ixCdNHoETZN7yL147+smg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)