UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'H6XBKCrSrFy9MW4abpyZQP6dg7+Y3dkOUU6Weyyodbo=' 
WHERE 
  key_id = '27c4f8d3930580cf81866f2586a723c16412af7ef6d761fc1392d7aec49f7fea' 
  AND (
    token = 'H6XBKCrSrFy9MW4abpyZQP6dg7+Y3dkOUU6Weyyodbo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039