UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lCjel7ppDR9de/rJXC3cOQnVHP4fDvaS8hILWh/w3K8='
WHERE
key_id = 'b25fa2d63322c54ec695f1f2aa807c8ee67735554a5adc5f0723b4b9927010bd'
AND (
token = 'lCjel7ppDR9de/rJXC3cOQnVHP4fDvaS8hILWh/w3K8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)