UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NFLRp8n7iu2QAhlw7CgUiJkOjaOH5T6xK6garOqQ8cw=' 
WHERE 
  key_id = '00c11aa6147bdf55235e0c1e71b9a78258e8e7ff85be9aecab796c789dab3b19' 
  AND (
    token = 'NFLRp8n7iu2QAhlw7CgUiJkOjaOH5T6xK6garOqQ8cw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032