UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NCwM+z662eOV8B++QtnUoil5+ZJmUO9KdU1I0RYyXUk=' 
WHERE 
  key_id = 'd0387f5e19e78ab4aedec9ce44c90356c8f863a17749070f5b59a9eaad6efebd' 
  AND (
    token = 'NCwM+z662eOV8B++QtnUoil5+ZJmUO9KdU1I0RYyXUk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040