UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QXIwwgX3m6ou8snQS+aDieiYJ6skPlhGGRb7zMP9QAg='
WHERE
key_id = 'e05bc40ed8cf44c8718e96666bf6910dd4da7458f27d85bc1f3d88cd8954600e'
AND (
token = 'QXIwwgX3m6ou8snQS+aDieiYJ6skPlhGGRb7zMP9QAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)