UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0zplUXx4ieL1iCqU1TpnCh7tMNVDm32BlTOLwUPU3Jk='
WHERE
key_id = '34720d75ad4cdd22b9031ffe2d7a6a9213819be9c5f03c48478e3532a200e9ad'
AND (
token = '0zplUXx4ieL1iCqU1TpnCh7tMNVDm32BlTOLwUPU3Jk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)