UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZnHx6SlP5SEUkAqMl5zXwg4VWQ2OZ3VSBa3777k+WWg=' 
WHERE 
  key_id = '99313d3d65bc2b4c0af0305baaeb897b8466b11eaa00c9d62ed9901a64df2328' 
  AND (
    token = 'ZnHx6SlP5SEUkAqMl5zXwg4VWQ2OZ3VSBa3777k+WWg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033